home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Software Vault: The Gold Collection
/
Software Vault - The Gold Collection (American Databankers) (1993).ISO
/
cdr11
/
pdox693.zip
/
TI616.ASC
< prev
next >
Wrap
Text File
|
1992-08-12
|
2KB
|
67 lines
PRODUCT : Paradox NUMBER : 616
VERSION : 3.0 & up
OS : DOS
DATE : August 12, 1992 PAGE : 1/1
TITLE : Use of the Paradox Resynckey with linked tables
Use of the Paradox Resynckey with linked tables relies on the
relationship for key field updating.
When changing the value of the master table field which is being
used as a link to a detail table, that linking field in the
detail table will be changed if the relationship between tables
is One-to-One or One-to-Many.
In a Many-to-One or Many-to-Many relationship, the key field of
the detail table would not be changed, and the new matching
detail records would appear as you would expect to happen.
The following chart shows the relationships ...
╔════════════════╤══════════════╤═════════════════════╗
║ Relationship │ Owns Details │ Changes Detail Keys ║
╟────────────────┼──────────────┼─────────────────────╢
║ One-to-One │ YES │ YES ║
║ One-to-Many │ YES │ YES ║
║ Many-to-One │ NO │ NO ║
║ Many-to-Many │ NO │ NO ║
╚════════════════╧══════════════╧═════════════════════╝
Many users will often make the mistake of thinking RESYNCKEY will
resynchronize the detail with the new master values all the time,
or report that on one table it works, but on another it doesn't.
The proper relationship for using RESYNCKEY should be a Many-to-
One or Many-to-Many. In addition, in a One-to-One and One-to-
Many relationship, Paradox always automatically changes the
detail key fields when you change the linking master table
fields.
DISCLAIMER: You have the right to use this technical information
subject to the terms of the No-Nonsense License Statement that
you received with the Borland product to which this information
pertains.